package com.wondertek.poms.dao.repo;

import com.wondertek.poms.dao.po.AlbumSalTicket;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;

import java.util.List;


/**
 * @author gzx
 */
@Repository
public interface IAlbumSalTicketDao extends JpaRepository<AlbumSalTicket,Long> {

    /** 查询售票表列表
     *@author gaozhengxing gaozhenghang@wondertek.com.cn
     *@date 2021/1/3 16:58
     *@param albumId 专辑对应的节目id
     *@return  专辑列表*/
//    @Query(value = "select a.* FROM ALBUM_SAL_TICKET a WHERE a.ALBUM_ID = ?1", nativeQuery = true)
    List<AlbumSalTicket> getAlbumSalTicketsByAlbumId(Long albumId);

 }
